SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45144 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45144 [ RunTime:0.004783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (396159,638955,576209,457439,837523,761511,118114,840857,454278,70839,336664,285569,462498,539518,109556,123615,74558,1020136,280233,952696,232517,212528,733669,14209,248232,1035478,833055,625762,437379,673531,721663,541974,632973,941045,687057,693979,408674,660360,52176,661896,167160,858531,554695,37932,412105,492929,579330,304329,763206,805582,279241,764421,100195,766429,663299,1031855,875125,37059,116077,586856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45144 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001897s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45144 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]