SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105945 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105945 [ RunTime:0.001734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620037,876591,532582,430727,250557,696825,172446,732166,708237,332700,145101,940043,700587,222799,572155,56565,657620,921356,776939,810813,358496,34615,423292,101049,178121,310950,497295,528706,780949,483486,496049,588449,1040721,487808,201744,756355,947453,850984,175384,967684,946395,655856,442467,1044898,84132,255992,442421,705829,492282,363242,659021,962024,473212,90868,234808,178165,263237,94315,282706,340332) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105945 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105945 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]