SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001404s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012097 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012097 [ RunTime:0.002711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269292,626115,544632,144991,881789,525930,390356,152888,589924,263703,261075,550891,368564,165175,670306,115332,83207,967870,410446,19552,870814,845855,936364,308724,620307,384274,942755,230619,527641,617232,552961,735958,111855,365167,1035954,680213,991731,895478,858986,1005076,308006,874587,183715,282789,938264,167710,439941,1015597,542796,622604,847420,440712,178092,467536,622411,272721,679290,4328,857113,612167) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]