SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539215 LIMIT 1 [ RunTime:0.000506s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539215 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (797424,397535,126141,377999,912589,532495,663771,399004,653401,252139,625294,1037365,549843,718975,642176,1018084,153271,852075,68190,124742,945444,354508,353002,224418,946450,196944,194965,716641,708330,663799,80549,608522,829403,587203,449714,860834,562448,727974,253533,214201,636835,858146,439049,689196,509443,742346,436059,451423,290249,188971,754854,913833,90703,652865,276909,787028,125606,627378,341466,451451) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]