SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391323 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391323 [ RunTime:0.001884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (303159,747787,298079,459514,178797,372127,123136,1003940,253566,970124,548103,462439,685005,860168,177185,61381,738295,1047585,118740,307148,513435,519031,173229,981522,820122,785793,900773,456337,467197,121100,863439,555657,587571,436744,706165,379996,35050,700021,943114,975976,879735,697573,459166,783657,801671,185851,100785,257679,927628,280352,20338,701113,262509,978994,498451,365282,140303,992259,135177,919665) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]