SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336512 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336512 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (709469,302620,96661,424314,350197,142278,904779,124364,1006271,464465,596002,405791,415694,1029378,811315,782445,881411,693864,27003,408359,517955,32922,650342,615258,850230,467583,261946,362089,755110,1016158,424906,177108,844495,777885,1044189,875055,84386,426163,621777,656708,925202,459515,428940,894772,283279,282620,977663,640613,378315,802514,39158,900254,298059,862104,1010132,830712,187112,94739,32529,461087) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]