SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512575 LIMIT 1 [ RunTime:0.000612s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512575 [ RunTime:0.003679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282175,277395,307252,867748,1005038,679896,911633,305849,960158,149459,720536,88523,657196,303394,471213,644460,647988,507307,393932,192418,44365,51890,908825,504278,539834,727642,627328,804921,832398,1014214,216186,1000679,263038,374810,94374,326521,1035663,370556,856798,577113,792195,411888,638318,30601,311918,64515,221990,952846,24563,104981,573265,400878,306241,736174,861976,903206,631699,935541,672073,936852) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512575 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512575 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]