SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001649s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 444071 LIMIT 1 [ RunTime:0.000603s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 444071 [ RunTime:0.001964s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (378081,556924,1019999,766350,141142,686956,283463,915657,693003,111925,522849,639795,1031117,409323,691415,163240,456350,33898,499896,1002432,1040443,980602,657013,950597,721782,395171,316461,793581,821788,832540,292008,585785,77235,845928,294591,572221,350392,1006047,524247,221113,378214,965567,693591,1011724,749371,488535,856825,570131,861635,975801,836092,1018347,519148,382126,984424,677346,779788,833320,794483,986813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001719s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 444071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 444071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000677s ]