SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 597314 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 597314 [ RunTime:0.002024s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (95228,330070,297518,39454,120531,284879,342484,209949,823228,966451,435841,27724,660451,714367,1028508,457588,230855,726797,450339,534823,333011,984492,2101,511280,475917,686139,572464,623119,515917,574554,806940,813878,877569,353451,78856,89866,434155,427285,363834,536994,848538,914662,37518,960961,398958,284364,54796,250548,885022,315935,478139,820069,666348,604732,491528,1006454,562286,716769,624554,843426) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 597314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 597314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]