SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004090s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425701 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425701 [ RunTime:0.003108s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440622,493328,666557,969051,863728,625387,762777,472293,307701,32481,1044458,686108,241019,783953,95994,103324,577216,1013675,633472,137296,720278,1005142,34288,117837,1010037,560455,576518,836158,1019703,63813,99561,878906,330688,788387,1020620,105621,946991,709194,788981,30653,248261,971068,417004,1020745,202333,557625,811666,15894,407355,830905,1017437,247078,770819,640746,675821,621783,55175,463716,337579,438975) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001894s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]