SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515841 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515841 [ RunTime:0.002022s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (884443,691485,550394,870762,874877,727477,648387,966434,383601,5318,770424,834514,145417,357356,217242,673958,890687,789188,30454,88550,554526,391432,818187,41691,521061,963944,513762,1032159,152149,473423,997872,74019,366610,337375,324143,757212,367917,407490,427963,494941,496623,764642,1025338,506508,865923,993372,835084,314916,891548,360739,110501,419132,293581,399884,313318,303209,631283,700806,631615,968651) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]