SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455162 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455162 [ RunTime:0.001971s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20960,192282,1011506,234620,307864,202825,712982,643068,801837,101129,1014184,674203,1028002,902991,217998,1035028,772580,490986,640572,774243,203074,644288,880119,745419,205343,103352,788101,207101,64813,86965,873701,943455,722455,583749,841363,922259,732373,499174,430326,237173,299679,68098,314645,389821,20657,867172,264136,1037396,634781,981586,278996,640312,645847,245895,1009998,543496,286750,108594,584070,934393) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455162 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455162 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]