SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549528 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549528 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269602,210425,920879,451650,709776,46590,929855,277502,866463,897838,589738,759454,365380,78040,761110,414145,325565,511884,207838,345524,830796,698439,756803,339972,746861,220084,501384,880373,762452,584851,92933,231867,317901,569847,85920,852396,511883,1009827,209346,358730,241240,48772,242916,1006180,416069,762909,170384,279433,315280,830149,220871,534603,596945,460091,243712,639094,799618,115277,150093,691449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]