SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509638 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509638 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (541106,181334,229911,403334,525401,763365,251252,856027,12875,312442,732317,810610,877849,446142,769674,537429,322643,304897,764260,1015823,414022,732656,557076,819608,167745,51488,572052,685240,605801,253051,685603,305624,238522,468477,441058,84532,556456,821179,494983,729071,671677,764157,717911,199736,562946,724764,239596,960865,446501,444316,228054,1028271,513957,104284,427478,243957,532851,811309,293672,103839) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509638 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509638 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004976s ]