SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487721 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487721 [ RunTime:0.001510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (769248,578187,242458,978640,177673,1048339,491107,431475,786081,9390,64652,542963,861044,247867,1016087,693376,415023,616301,754060,694786,949300,683722,82935,812464,326474,696198,624547,26529,621740,770808,854199,1005638,421611,255446,502218,840496,818247,686622,895662,683956,89096,465386,42907,371103,528970,281565,150731,753373,465303,733655,360005,13380,267277,698357,525902,990741,977045,246112,732006,925760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487721 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487721 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]