SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012899 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012899 [ RunTime:0.001766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (726339,292671,1019556,588673,416798,600076,168816,892819,686646,543214,867276,984892,153394,437833,6987,507243,315675,262015,868401,32350,92066,22515,487799,830435,577199,340944,220947,867929,918392,134778,113298,935682,788587,650358,126887,728233,1042284,457355,1021112,16700,950439,161468,610652,477796,447017,143395,436361,615319,373319,273104,406603,638035,440239,148686,854375,176605,364961,211007,533630,161377) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012899 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012899 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]