SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012427 LIMIT 1 [ RunTime:0.007990s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012427 [ RunTime:0.003687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005622,118647,869258,785375,729274,352237,243589,177404,199311,543894,402395,425609,499590,382698,148093,453224,462846,48999,57161,298170,1013830,895736,605909,679123,854281,937795,36358,629005,703688,823136,371289,887023,385844,52913,746534,529771,949693,880297,804455,909298,665034,518685,193008,658487,365280,819625,84267,604730,141954,272846,99126,803516,874443,913596,855922,709565,916042,45282,864229,367740) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012427 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012427 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005327s ]