SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005615s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519301 LIMIT 1 [ RunTime:0.000912s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519301 [ RunTime:0.010525s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (256269,808609,322633,1040784,267935,1025015,853428,960266,564266,218321,953004,737782,87001,857732,536388,915604,490835,380477,107515,914333,380573,390595,992522,969224,163081,15381,589043,310275,471559,87695,971729,1020033,973999,1014278,172559,677432,985214,686289,919227,886940,779502,364070,504889,879368,65415,143788,994899,544022,373620,274940,798234,103299,111452,26884,134340,458791,630400,222862,443425,1000395) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007755s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.006897s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004081s ]