SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 14147 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 14147 [ RunTime:0.001990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (205642,84750,896239,446104,29680,661729,1014368,1048471,342641,983309,242606,730485,269517,445438,738048,421080,956578,819481,997269,859254,995668,925306,971682,785257,1038399,437782,644139,140925,26904,645633,602633,116607,199300,339911,27604,843405,408776,933600,1048178,81410,562001,535389,408134,628603,86418,614087,756794,499099,409670,1024125,931628,236944,520234,684328,753384,16161,35197,457858,40077,1041481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 14147 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 14147 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]