SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001729s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493380 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493380 [ RunTime:0.002571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022370,717436,729739,872842,949537,1041263,226455,316739,624143,1017034,647312,421336,218950,960174,42559,911577,854988,565921,890972,1026645,599473,882439,540210,754714,932790,11422,435383,875857,395099,489937,833365,486925,486220,127665,738917,433178,614789,365010,335291,349279,643157,739543,959254,786669,793068,799064,433787,886305,54218,114340,984095,62160,833994,258845,279869,702725,792158,392735,968500,253390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]