SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411090 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411090 [ RunTime:0.001741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034170,443772,524491,929666,1014072,809926,448409,1024188,108638,541676,970808,50959,692903,867437,939537,521479,169900,562015,3235,442930,207667,1041704,754339,559073,473875,30679,377537,862715,8025,126867,770280,304404,30853,246323,897452,384421,855312,85705,651787,930389,1014156,433457,818119,1012635,992343,42496,480730,63419,556127,603039,637775,623711,198707,647992,318979,667113,487574,842658,671227,707920) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411090 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000603s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411090 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]