SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 654094 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 654094 [ RunTime:0.005817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252583,431424,54633,34099,204632,68725,333341,856119,967720,506813,203391,477368,506138,188854,569241,1026008,391625,106420,889508,719973,314382,922794,402387,429801,356837,718338,123521,319595,236135,886479,124704,14330,544159,155006,818989,1007963,483260,946161,96835,953954,74535,165905,670784,232228,1046173,706531,817926,866735,88506,218788,455161,12447,754953,50650,998086,65650,1041662,144455,600523,575323) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 654094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000686s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 654094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002038s ]