SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196988 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196988 [ RunTime:0.001520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (596516,446100,838027,516653,193597,979810,283079,475434,463681,116677,1039025,755857,278354,745149,809159,453668,1028156,1036866,909338,313101,473268,157038,779853,241864,1043199,841877,34510,193375,906153,405423,381514,423567,349333,432084,256908,394443,93960,71573,19554,921676,504019,811860,797922,894923,528757,77252,534303,909626,834198,794920,90277,696178,270941,793683,987910,500334,748005,643729,232527,746168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]