SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107399 LIMIT 1 [ RunTime:0.001086s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107399 [ RunTime:0.002376s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (726501,1000965,103425,561877,820918,216632,829058,129251,193171,901168,157592,760000,929899,310032,737605,954860,362270,380561,729281,701822,673705,578413,171479,793397,838170,464348,54278,151337,61826,144576,115987,27913,381258,378934,1013826,955169,242423,126342,973539,600959,1028368,818386,348920,363033,819888,20528,879066,582892,1042335,243101,161362,980131,913834,517124,990913,632131,419619,961933,26897,567390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]