SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310224 LIMIT 1 [ RunTime:0.000522s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310224 [ RunTime:0.001980s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (730143,544707,891276,137193,974791,741303,583782,153367,598228,18431,629178,20872,862718,183321,5070,737059,630472,984599,93331,787207,261708,594095,34571,580843,312649,451447,382594,705500,335721,403964,137484,296422,777612,123446,374964,671291,563172,539146,178659,905803,944808,263464,301139,1003155,122132,57094,97066,943568,757987,1026126,363659,979574,496286,802975,36392,739799,314146,922542,15697,516001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310224 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001674s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310224 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000404s ]