SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422718 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422718 [ RunTime:0.002847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281725,320084,936531,42819,233935,97718,788658,266261,498642,184121,773185,833750,925549,466889,159369,791987,213370,348513,590423,189772,336923,309426,582298,253713,658323,174283,154613,712482,222199,257704,42741,846188,840038,104356,1045564,632212,470652,167018,314013,1010018,262322,803773,825599,118215,744206,877994,617300,28205,832352,506195,278434,101965,278716,19755,349786,700191,779601,486388,324395,971477) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001368s ]