SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405098 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405098 [ RunTime:0.001960s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (203475,720893,329803,666492,18564,579840,461212,939754,994125,197120,285030,968655,290967,233319,449177,449820,307310,424820,307900,518627,6373,171938,972503,475230,308430,686436,777277,895743,319151,1009441,325318,43267,422268,692603,167123,196995,26937,30255,519327,653939,178535,367352,679138,57415,1030063,97030,594966,903826,139428,64105,426067,223264,229350,965641,704940,442994,559189,713264,226887,145580) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000828s ]