SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498741 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498741 [ RunTime:0.002607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (591105,306260,329960,797678,645218,861583,580087,251662,554594,414940,420189,571169,162404,942316,186433,623810,284217,576229,560747,836890,341699,309945,645830,1022284,489865,444966,663404,903050,678354,273361,55488,341773,149949,497821,827171,438096,500943,872633,551047,623509,1013344,861590,464791,779327,191218,482455,369020,634044,372423,1013700,926972,793902,971513,287327,559612,780305,226281,207165,825936,366506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]