SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 898580 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 898580 [ RunTime:0.002076s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (886491,925214,802396,214680,65719,263755,267205,269224,928217,493274,558071,307003,787720,752948,303101,289400,185080,533999,308422,939486,203727,111765,553199,622889,958850,262049,284318,378525,587469,231503,317427,962621,172850,505827,333527,865288,109181,814789,42957,296488,835449,834269,950040,261970,299037,766644,131312,424494,482780,602633,148873,645152,42553,198934,1032947,149420,976982,711287,453864,622082) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 898580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 898580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001036s ]