SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5139 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5139 [ RunTime:0.001462s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516211,807368,411263,332534,919725,849474,856558,260604,1043366,507862,641873,176325,975770,241538,52533,324065,833997,805348,368749,798422,938570,337972,312069,440210,731586,1032024,757040,591176,60523,781795,888754,690885,773922,812173,735372,632424,527148,760501,809619,181078,95382,168239,975347,953770,261094,526035,773894,966962,389258,45916,623526,732347,346484,865374,204346,416221,93346,660093,1028353,174290) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5139 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5139 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]