SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470314 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470314 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409011,155013,234939,751913,841794,330387,460395,311227,817123,408156,493754,1038658,40947,216206,827220,539335,28905,946070,558491,287787,416159,1042917,105288,798835,692392,989939,403342,810837,751296,403825,839965,381911,114281,275054,890481,527310,545075,29280,130645,895841,403171,620586,504166,214795,542252,168804,1009461,549901,743467,53327,493181,854980,737606,953744,537579,913921,919954,2256,51394,66566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]