SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001542s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524813 LIMIT 1 [ RunTime:0.000491s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524813 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (268243,84708,872404,731161,509117,969708,684083,273244,461674,432468,611013,258682,510783,170576,214515,725081,653302,230565,25182,482742,366344,249258,861903,168672,625120,781459,776743,320122,61288,74408,539208,744773,30542,635134,428591,216343,942573,751345,1020258,985563,646678,432405,649088,879593,435012,899105,336871,514070,672622,320955,77421,131466,186850,39801,573844,645549,1022163,863709,726060,97252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]