SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31811 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31811 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (46434,973391,80938,1012762,1019502,688360,721794,264461,554099,803206,493657,435815,707452,541516,666244,218426,388566,166040,242358,331773,603947,117834,631204,1042549,765258,906078,1025591,308093,688302,607158,743850,122409,684393,340113,798552,28838,523621,69548,152142,886473,748742,499209,692710,989184,865826,118320,637050,143067,891014,50776,856670,872610,28954,835187,1045926,248742,97835,377131,654971,863507) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]