SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564201 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564201 [ RunTime:0.002112s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459447,170201,106515,138410,153057,364115,610075,845493,390958,658463,437822,608815,94048,546310,687413,98823,330788,755642,182491,390544,878713,125616,763710,101610,840264,304427,254385,590595,730082,450970,685286,118721,669873,343285,778468,701179,834019,545617,409513,163287,214171,498086,45104,1110,853387,981565,486979,1026645,295844,920600,543535,128553,797994,149482,120670,470848,211765,875185,306357,85807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003613s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001072s ]