SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021010 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021010 [ RunTime:0.002001s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (134564,844563,761359,959560,373804,608163,42058,993346,888637,912463,562679,904437,929381,812106,196435,611217,926310,891250,435905,823153,752430,916670,622898,53231,390304,950541,633452,921570,221014,329830,747268,340987,421878,368068,827420,65522,291908,95926,45095,329500,493243,522190,1044037,671336,504517,485975,996492,127119,42335,768548,917938,943730,100994,812630,914856,16303,108747,559099,375158,585131) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]