SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453438 LIMIT 1 [ RunTime:0.000562s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453438 [ RunTime:0.002306s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (47329,406917,888441,933179,360027,1036156,1043594,876856,842821,448038,850205,1007911,307671,65806,726589,208211,82892,531239,759740,181741,64869,826836,177084,453437,69365,936740,1009150,327206,32412,94705,701219,989989,669764,201589,725275,942895,1040615,381683,1019526,686176,645492,358670,597495,619273,579828,514638,261679,948158,428832,818980,295556,994948,395053,122280,559069,683384,499106,479589,448693,131868) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]