SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50428 LIMIT 1 [ RunTime:0.000607s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50428 [ RunTime:0.002045s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003684,308552,123496,928447,686044,698262,889617,69934,645651,380251,481567,131835,1019275,1004597,317186,526130,652347,907592,214813,610926,625865,38948,457106,848015,363894,354498,451232,327571,796251,627200,542351,126924,138833,468958,76599,1018925,785002,323312,356807,361443,944865,884439,107727,801335,191662,551012,400573,259076,137008,377861,924959,211273,501609,429697,649471,446378,73428,310610,308990,966645) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004655s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001814s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]