SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002085s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513972 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513972 [ RunTime:0.001552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295916,308056,143634,148638,598767,326409,778023,536443,482356,339956,587515,557353,193861,1039344,672139,257071,425093,720259,16851,788384,795074,710419,25066,889559,181092,744808,990561,294054,771146,1038023,405614,456220,341441,184821,101741,617379,253112,725104,22555,51320,674117,651021,141826,370912,404989,675941,146174,1024166,971235,225313,305303,721826,216902,257622,149126,301313,623061,619643,666844,673449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513972 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513972 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]