SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505858 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505858 [ RunTime:0.001774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469205,349219,1003311,999412,931513,839985,290608,343952,626293,113339,527622,840680,108142,20679,240985,624151,968648,449511,317911,840809,917124,55658,810364,493878,453587,889403,762271,363070,579870,624491,374391,558661,194362,23519,259492,878165,761950,799095,389807,116792,65289,725467,276086,1038060,630489,701797,422323,516110,513519,682056,341891,1039894,221089,627270,204554,558282,963810,329877,1042200,75991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505858 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505858 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]