SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037641 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037641 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413172,683784,973959,208836,159892,541255,767942,261380,498441,1001474,253327,910074,508793,78089,1037732,129892,577546,935847,111138,937301,23248,434141,666935,832214,849900,287803,1023862,965564,579081,418374,148459,851791,528921,546667,324910,985153,317767,1034987,243193,207065,583206,151894,267640,801552,455544,363567,798951,1006864,454432,587699,985147,926768,856027,310652,851693,480379,685566,122406,197108,113998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000929s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]