SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422551 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422551 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (867381,100068,979254,274305,524306,400484,156202,131950,1002384,203047,439152,722748,889348,341649,149908,904720,488430,385962,430605,498097,928483,185649,724089,368281,49677,597370,70240,1027883,148310,1029050,285119,733961,894784,661427,851419,868504,1045139,619163,348230,836204,150559,57682,381091,664858,319034,651155,811062,599639,565389,728170,301457,604001,269719,660586,903431,308371,748926,59886,98255,194447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]