SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002083s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030212 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030212 [ RunTime:0.001620s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (372439,193114,979707,431412,599687,203945,21945,338987,554909,769091,645640,237711,595866,103193,354292,61016,25690,17512,307705,652475,401705,8988,650675,468323,727140,527243,428128,732400,1037179,201075,299937,527446,259760,896003,971404,249578,719376,79163,618541,705110,128703,980753,597682,114809,540662,816603,247336,895100,124782,891140,20657,283256,1046710,410957,181407,226831,362238,500391,722585,546266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001589s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001617s ]