SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002800s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 187428 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 187428 [ RunTime:0.003285s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (851677,212737,845716,124890,1007818,164074,785261,384216,1041662,434909,524963,556578,341899,902961,194810,603795,337188,339632,1047592,813914,999316,952433,275095,23896,335114,703278,187309,251875,160740,461137,70167,115702,886124,582287,252344,368190,383970,438814,450092,650489,681693,366774,437435,497732,958398,181781,602821,854848,383894,708281,629584,643525,655514,892512,988714,494783,883928,205482,335788,425061) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 187428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 187428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]