SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526051 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526051 [ RunTime:0.001934s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (35666,161874,242829,669335,812421,531916,827193,469200,308371,881337,838427,398508,146086,840367,652012,771689,270432,788961,597142,970557,941152,873770,467045,15980,165574,72146,92869,220789,899278,1017074,46994,1013521,944080,712425,356612,682315,908417,979489,137369,267850,208404,132282,901771,542304,1029011,477514,260167,639397,407654,507602,1029934,977204,808817,375013,561034,220342,157279,1008644,684084,664972) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]