SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001991s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467614 LIMIT 1 [ RunTime:0.001494s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467614 [ RunTime:0.006673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (596902,1022365,718892,903720,201328,446586,395983,28143,852147,577093,1021043,100096,300757,865564,689376,406120,739745,239854,215491,826490,115203,741559,739897,258888,917125,291423,212133,881094,1041643,272144,974471,658255,259848,750628,630306,368124,4324,972212,916510,731563,855560,905661,888722,926572,229991,624628,714133,712947,826945,399826,1043248,704442,677093,824845,416748,711664,229962,472380,659263,987945) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467614 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467614 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000677s ]