SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 59501 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 59501 [ RunTime:0.002792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (230381,710876,84032,816391,359595,672428,388824,650,794511,291409,426759,114375,984845,575613,43323,1014897,383861,645034,762836,165395,474475,758565,247128,728559,902234,371550,193672,315022,725618,689341,779218,1025052,896013,700264,11843,32415,988062,934681,790980,33052,680087,425672,329477,305829,549965,910575,1031353,264622,49580,925640,66972,479634,231919,261649,738244,124696,444982,358927,532033,968851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 59501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 59501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]