SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 641020 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 641020 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (696917,800795,1011127,395398,1006705,646417,382532,428787,865996,366977,1014274,480709,775638,876583,301567,318918,314725,376811,29730,60303,688288,259459,896867,1032364,237772,613951,770950,867452,392975,742709,813155,474857,123119,667888,927479,100773,425040,932149,146214,888038,630309,223620,22994,770842,471877,846902,889653,493999,897274,763561,270363,993329,485657,262189,944193,1017704,791743,326398,57515,281359) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 641020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 641020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]