SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280423 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280423 [ RunTime:0.002049s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (307722,58890,35042,1026244,986670,944659,566928,970430,34139,478944,779526,44534,562960,239563,602495,310179,103272,813940,189710,333339,331663,449071,322134,321017,251381,118535,54872,348239,363798,723083,383236,443705,605056,64425,615453,617334,562065,401003,632585,780686,836249,197986,533841,198153,731452,520700,630099,106662,690389,551328,721263,577348,954181,739949,1019518,882462,37496,175970,382206,927812) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000933s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]