SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482396 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482396 [ RunTime:0.002143s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (258019,834530,510174,342800,930063,247197,939220,53991,421165,490389,960476,482049,361484,555614,488924,989639,117381,34814,745722,564675,756517,218952,826354,630709,584217,197437,453800,415491,631208,315968,625331,776986,216499,563765,654946,501616,823458,543764,602522,869931,40071,954922,595680,808225,180233,535435,860778,679049,168487,837381,840102,874659,751002,71611,383589,36037,197120,793897,711072,938555) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001650s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000668s ]