SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019505 LIMIT 1 [ RunTime:0.003236s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019505 [ RunTime:0.002582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (986031,217788,788527,736222,887499,873915,894077,268010,152870,995438,482023,34751,97887,444058,837118,677105,771125,414058,1005793,806433,554987,860276,845274,19947,55582,299153,118180,911944,212251,739226,859595,340715,968447,206914,208781,549671,588141,326961,972837,775489,268274,849352,199002,640177,947046,140642,684639,816728,780970,333070,804893,795117,480355,1023285,538815,507286,478496,277898,215883,579009) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]