SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518216 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518216 [ RunTime:0.002297s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (386357,801304,173201,880909,617718,846759,43460,3675,293713,805443,512166,951982,688477,111262,365654,394424,187353,594775,641126,894617,518089,1020908,864295,903827,691060,639704,806649,153108,1010415,584125,225190,843213,425207,923221,1014234,30468,900500,23726,25011,465063,971544,865836,198927,256613,1032724,282916,129200,322347,62244,936224,151956,135092,1040848,644144,400863,719267,867369,171346,459033,395556) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000690s ]