SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396310 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396310 [ RunTime:0.001805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (531310,900794,648727,627691,739239,911332,18426,240506,32027,270276,619059,391906,528558,154160,320002,993770,348020,180533,702159,548220,453319,87577,1002866,660670,159164,82334,114582,275637,324936,583025,699280,501522,13837,167157,4833,588661,391244,739468,472556,305590,506195,538262,648969,258135,262653,1018275,463900,724670,9968,765247,857539,750639,469595,790210,1011924,7331,6288,295238,984301,876035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002068s ]