SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001497s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501248 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501248 [ RunTime:0.001819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1038091,770920,720194,411165,452059,336022,201840,89163,497895,912509,275501,680172,134480,214052,449600,849972,849802,979907,941169,420118,462595,232710,838061,493978,283039,216902,213699,540604,237589,733572,178793,61448,13629,900968,376078,105420,577235,694382,238531,995594,523057,884547,832590,964398,452874,661172,847230,440925,987446,193244,946629,905832,308626,290734,910080,750157,630857,443401,952273,561874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501248 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501248 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]