SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38511 LIMIT 1 [ RunTime:0.000485s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38511 [ RunTime:0.005411s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413135,845385,265601,245806,762246,721367,307395,322095,464901,446229,760034,855325,302693,811250,319403,110547,815511,510125,706603,50720,107189,832985,799546,871114,417193,312818,711040,72971,374481,455082,239547,680995,930556,996182,261674,73498,694653,739650,283170,529288,792867,285860,462535,564109,793403,881363,953677,866074,205645,989556,166449,647760,803474,441020,690459,573735,997819,1038755,239745,896105) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]