SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105158 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105158 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (132909,378528,36900,441512,42309,946325,442745,698244,611750,1043976,362634,109619,430578,582351,358330,72431,642393,1037792,736336,381417,119121,82959,195774,3236,575462,235305,384668,562594,343017,442900,97893,798467,590152,1012316,644428,5921,876767,881308,527819,463466,865398,527104,663630,24770,71515,242908,949229,253921,230922,915382,968691,1042284,999157,65605,897206,188044,861237,5993,499337,273198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]