SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400108 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400108 [ RunTime:0.003210s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (210415,212857,913584,548413,243301,434756,539700,123170,527890,73576,589564,440768,384725,518692,645429,191183,984866,100244,190183,836396,283927,961162,201944,292162,120505,243686,605299,875446,323774,505176,624488,256054,581095,770081,165400,504022,816691,317923,33540,963471,5005,420744,220862,87583,635376,96947,894621,780690,578892,917835,128277,809967,511133,631833,725826,253544,718014,796431,146796,833827) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001806s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]