SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023317 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023317 [ RunTime:0.001846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (895626,922889,243123,412578,200229,930003,681653,140844,126761,295846,996534,177831,255748,372586,583315,264885,528063,848784,151747,472646,110301,813582,643691,732201,966225,552498,104497,1027028,391609,914605,556540,804428,869590,1017179,960173,297752,381914,542965,41580,184106,921660,1024268,368895,403715,1028637,542219,913084,417258,97788,206001,894235,77238,508850,749306,53366,523722,201091,100218,984096,521970) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]