SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500543 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500543 [ RunTime:0.001838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (389239,130541,766538,62627,504088,44897,925224,1042299,201018,616017,175342,770578,434964,645584,107790,92994,339232,1035592,986618,227482,861967,239080,263918,811409,111164,891435,798475,477054,277666,669210,338707,186281,964407,387119,955717,288961,721665,751838,88563,819484,893080,797153,289275,1002351,947623,212738,892189,141443,293332,666181,361969,372858,415987,575182,602460,503077,481920,480505,875629,406987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002019s ]