SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003592s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 156791 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 156791 [ RunTime:0.001972s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (605104,251455,284294,132057,772928,1021135,122335,577612,167758,835003,37478,123638,589966,1033376,834171,536337,457490,209855,5875,647458,117685,11676,550081,861711,383047,404295,375180,522374,497298,291454,307347,89824,668293,197556,953511,117632,959723,780728,89185,326870,800562,713039,250280,877862,639151,494789,1044572,386822,801431,875710,162244,516530,26294,679836,373997,100330,621841,753224,671826,488927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 156791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 156791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]