SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 961443 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 961443 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (914250,711214,359981,585262,733497,779903,477673,171075,216884,481662,729326,905343,505835,552991,41444,246252,712089,373795,1012819,336193,14676,840463,360381,299624,710804,328442,44239,854209,111682,224261,833450,319787,1773,508686,39756,513171,1010733,549923,245671,477935,153986,560637,445913,926782,255797,511428,496214,375444,365859,872538,931588,524739,417724,818382,281242,263998,704197,945747,29982,803116) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 961443 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 961443 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]