SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420150 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420150 [ RunTime:0.002113s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (259449,436538,977575,158124,821859,108499,311277,82374,1621,457166,97937,818823,896101,903373,340178,668532,154380,358748,234006,159545,809402,432989,239764,596006,546362,994965,994765,1015830,284182,327007,684618,818136,293590,178909,65961,275144,399135,554035,535375,214184,163914,76434,525886,997013,637966,308864,372826,75399,890708,566171,1008771,203612,466793,492066,1043928,687087,342231,899850,54489,132053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]