SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 364318 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 364318 [ RunTime:0.001473s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (172587,101116,786004,1035321,1012666,953944,592012,394074,535169,600063,156638,723368,883350,33824,901991,172092,351131,883311,848601,109155,128874,1048711,507355,612642,9565,416217,332453,137842,83543,1001875,337662,228873,431467,92712,741251,645605,803317,554508,502120,278561,22518,866386,535619,126835,773511,638377,309239,772445,249370,830680,1021979,187388,1002937,774687,270743,486783,331433,233744,115909,101293) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 364318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 364318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]