SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301211 LIMIT 1 [ RunTime:0.001182s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301211 [ RunTime:0.003557s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621997,354054,657588,782715,305947,886831,664674,779514,1010469,961265,491182,131871,11959,481115,222639,167966,484834,28612,389824,188554,38707,62450,498981,107688,915037,374158,552134,595281,906766,330710,959274,794859,759219,885858,827750,73464,689740,592506,113004,722233,815215,351309,470803,102447,263020,187116,343318,363526,337721,686223,451389,172823,263615,936089,623936,8159,827519,65103,923813,136829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004660s ]