SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536590 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536590 [ RunTime:0.001537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026166,306317,560050,884090,779836,366384,687114,956011,292844,88095,374715,95416,905644,669857,498199,984536,346516,539480,337337,540130,216471,62035,926684,765819,301784,713963,822034,196098,43890,407870,328757,1043109,26101,193726,961727,5572,557738,83253,207554,984534,88189,442571,250147,767038,724102,205484,251994,585871,306396,699776,871037,920324,158680,22272,198063,859825,565909,775404,137246,452046) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536590 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536590 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]