SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001470s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301183 LIMIT 1 [ RunTime:0.000663s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301183 [ RunTime:0.001867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902252,261302,980542,751782,309837,742204,1287,913447,100343,993488,708323,924683,638308,96858,620510,464897,95692,444818,698447,73971,382197,310828,189785,8458,251456,280281,785300,610391,447089,712991,440233,580297,883291,486531,236636,69975,360507,541068,663778,347310,690919,1023106,67313,658053,431918,724482,81596,990049,762579,502085,224805,556524,502216,850432,565421,799460,366218,740270,823405,557755) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002932s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000690s ]