SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542595 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542595 [ RunTime:0.001735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003941,335667,923734,1041012,274341,746080,500831,369695,432113,186314,828572,277325,869776,829050,756910,502590,405753,111167,148658,624460,220792,59690,101582,515515,879985,320582,193425,1007148,292132,769869,456246,591398,421874,118142,767163,89957,480923,258488,908342,116599,774875,535156,183417,606371,1021246,299232,121190,38097,638942,514748,36953,523737,575568,223209,783043,387468,1016560,946539,756542,14177) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542595 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542595 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]