SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583836 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583836 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036307,323465,751121,1041659,69621,244881,778559,729953,890837,974884,708978,307490,753968,179612,79923,75005,344266,227274,595303,283023,552508,92525,836064,617564,157326,208294,278430,368120,844639,161598,381727,796732,670288,192359,493668,398104,1003160,993066,680389,342068,133128,103379,549928,788673,155611,547769,73296,711638,911154,54080,604281,534041,964462,891326,985661,831610,521266,64974,623034,1000557) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583836 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583836 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]