SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010199 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010199 [ RunTime:0.004462s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (755131,471857,1046743,56318,44354,461651,828397,243595,1035619,272452,1045688,793611,376797,974586,253705,458839,804142,407649,454102,226609,844371,952363,903203,27826,420016,865551,899447,722266,947031,45998,206573,219631,471038,179708,776146,259847,373850,315855,846257,144960,738703,478046,572049,883895,875918,945688,739066,273545,365344,454475,503009,115945,500585,38502,970394,478125,1834,743436,203515,287378) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010199 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010199 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]