SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040410 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040410 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522335,509423,345458,972442,359181,601938,394051,740787,706684,202142,934235,513364,1019879,119789,416884,1000,1035948,359685,714993,3172,640347,783582,413825,473406,1029068,496215,950844,622779,79000,886979,682335,502482,974489,700603,952993,209614,174781,96831,60864,741996,433220,242572,346926,911205,273087,946526,1003727,1008327,931073,478131,174170,356906,82937,122278,338218,972500,694366,630819,85206,872650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]