SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001477s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532619 LIMIT 1 [ RunTime:0.000639s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532619 [ RunTime:0.002119s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018495,364412,319591,43690,508655,312231,1023016,11032,811940,731363,919311,815458,814096,53298,648205,232470,818864,39243,369251,136678,970950,1033233,4407,878747,225844,901423,284480,4484,808535,782746,325863,776083,215408,620583,991886,616502,54773,679986,891041,331162,27113,948026,589852,938024,376598,533932,717710,720360,728057,285224,313638,467105,16911,667920,337800,203994,634157,246199,185732,36509) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532619 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532619 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002561s ]