SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 36800 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 36800 [ RunTime:0.002061s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018400,741169,670597,299352,934110,385459,245321,294645,1018533,804182,3187,662958,702592,729666,475578,169740,457955,988106,259098,687431,96206,583075,338522,933718,523108,1033362,9433,362403,21938,771249,727270,856522,708730,72067,759071,792939,658720,970992,995729,549297,931945,149472,271010,701193,531847,928444,98299,76783,747655,366301,20547,102132,55474,314845,407766,2835,45000,667909,125619,863918) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001861s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 36800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 36800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]