SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 939800 LIMIT 1 [ RunTime:0.001428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 939800 [ RunTime:0.002907s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501929,417540,4634,566049,510799,328351,419820,746286,813623,361294,699835,879770,690938,999494,1009710,762174,650983,222969,810240,1036741,342413,299957,458146,115692,986603,665098,512902,711012,401184,938571,562796,118390,298526,257662,863083,407237,991452,615389,997833,241323,964344,543248,845511,331672,198902,638453,728038,115018,366935,891583,640514,415300,984536,103759,193670,2261,328189,277859,729193,213020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.018246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 939800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 939800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]