SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 574284 LIMIT 1 [ RunTime:0.000758s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 574284 [ RunTime:0.007277s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (837051,129269,1020128,427793,876791,220452,428313,184251,358322,467739,438119,787856,893015,532378,725665,936952,807019,736829,625734,772000,114011,909569,194730,507156,201456,309332,113572,551021,732949,939131,1021535,982922,811315,510056,940705,195359,993485,711952,803004,213250,258181,286436,864688,285117,495054,132461,789171,773296,169335,388496,12972,722676,444233,876719,654499,232647,707116,654349,61236,315989) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 574284 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 574284 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]