SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002056s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046713 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046713 [ RunTime:0.002322s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (564042,523200,392362,146322,902689,381584,67725,915514,919617,963908,2515,1042323,357316,115091,108758,712990,190767,240134,391511,454714,177658,701509,357772,838807,503802,507399,649341,1019439,547687,552861,960907,123295,96894,513846,523026,510978,1026655,680134,82290,304442,361605,264324,963349,819674,626771,161061,229106,19764,348089,1036721,348747,89758,79888,159726,55199,613333,603269,677294,148784,91433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]