SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473628 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473628 [ RunTime:0.002327s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (88890,884494,1000810,789075,424794,564134,660370,428000,328423,657879,29400,503068,538140,442493,602757,167244,249608,442231,789333,869918,858202,79672,916996,607909,351592,967121,346657,675748,703531,118232,1026263,922340,951358,678549,266403,317479,745538,707097,240470,189616,835043,657863,204959,416508,276507,644438,1021472,965887,243462,678224,731923,115750,520917,332363,697020,577701,757876,1013285,49111,696377) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]